CREATE TABLE LAF.APPLY
(
    APPLY_ID NUMBER(*) PRIMARY KEY NOT NULL,
    PROPOSER NUMBER(*) NOT NULL,
    NOTICE_ID NUMBER(*) NOT NULL,
    APPLY_TIME TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
    STATUS NUMBER(*) DEFAULT 1 NOT NULL,
    DISPLAY NUMBER(*) DEFAULT 1 NOT NULL,
    CONSTRAINT APPLY_USERINFO_USER_ID_FK2 FOREIGN KEY (PROPOSER) REFERENCES LAF.USERINFO (USER_ID),
    CONSTRAINT APPLY_NOTICE_NOTICE_ID_FK FOREIGN KEY (NOTICE_ID) REFERENCES LAF.NOTICE (NOTICE_ID)
);
create sequence APPLY_SEQ start with 4;

INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (1, 3, 78, TO_TIMESTAMP('2018-10-02 11:51:28.407000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);
INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (2, 5, 78, TO_TIMESTAMP('2018-10-02 11:51:51.566000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);
INSERT INTO LAF.APPLY (APPLY_ID, PROPOSER, NOTICE_ID, APPLY_TIME, STATUS, DISPLAY) VALUES (3, 5, 21, TO_TIMESTAMP('2018-10-02 12:28:35.339000', 'YYYY-MM-DD HH24:MI:SS.FF6'), 1, 1);